﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
USE [ActiveDirectory]
GO

/****** Object:  SqlAssembly [System.DirectoryServices]    Script Date: 04/01/2009 08:54:11 ******/
IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.DirectoryServices' and is_user_defined = 1)
CREATE ASSEMBLY [System.DirectoryServices]
AUTHORIZATION [dbo]
FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.DirectoryServices.dll'
WITH PERMISSION_SET = UNSAFE
GO

IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.DirectoryServices.Protocols' and is_user_defined = 1)
CREATE ASSEMBLY [System.DirectoryServices.Protocols]
AUTHORIZATION [dbo]
FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.DirectoryServices.Protocols.dll'
WITH PERMISSION_SET = UNSAFE
GO